package com.geekchique.runningbuddy.provider;

public class GeoPointsDBSQL {

	public static final String CHECKPOINT_ID = "_idCheckPoint";
	public static final String CHECKPOINT_SID = "__id";
	public static final String CHECKPOINT_GEOLOCATION_ID = "_idGeoLocation";
	public static final String CHECKPOINT_NAME = "name";
	public static final String CHECKPOINT_DESC = "desc";
	public static final String CHECKPOINT_IMPLEMENTOR = "implementor";
	public static final String CHECKPOINT_CREATED_AT = "createdAt";
	public static final String CHECKPOINT_MODIFIED_AT = "modifiedAt";

	public static final String GEOLOCATION_ID = "_id";
	public static final String GEOLOCATION_NAME = "name";
	public static final String GEOLOCATION_ADDRESS1 = "address1";
	public static final String GEOLOCATION_ADDRESS2 = "address2";
	public static final String GEOLOCATION_POSTOCODE = "postcode";
	public static final String GEOLOCATION_COUNTRY_CODE = "countryCode";
	public static final String GEOLOCATION_LONGITUDE = "longitude";
	public static final String GEOLOCATION_LATITUDE = "latitude";
	public static final String GEOLOCATION_ALTITUDE = "altitude";
	public static final String GEOLOCATION_MODIFIED_AT = "modifiedAt";
	public static final String GEOLOCATION_CREATED_AT = "createdAt";

	public static String[] COLUMNS_IN_CHECKPOINT_ENTRY = new String[] {
			CHECKPOINT_ID, CHECKPOINT_SID, CHECKPOINT_GEOLOCATION_ID,
			CHECKPOINT_NAME, CHECKPOINT_DESC, CHECKPOINT_IMPLEMENTOR,
			CHECKPOINT_CREATED_AT, CHECKPOINT_MODIFIED_AT };

	public static String[] COLUMNS_IN_GEOLOCATION_ENTRY = new String[] {
			GEOLOCATION_ID, GEOLOCATION_NAME, GEOLOCATION_ADDRESS1,
			GEOLOCATION_ADDRESS2, GEOLOCATION_POSTOCODE,
			GEOLOCATION_COUNTRY_CODE, GEOLOCATION_LONGITUDE,
			GEOLOCATION_LATITUDE, GEOLOCATION_ALTITUDE, GEOLOCATION_CREATED_AT,
			GEOLOCATION_MODIFIED_AT };
}
